CREATE TABLE [dbo].[TCRETE_ANUL]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[NU_COMP_RETE] [dbo].[TD_VC_020] NOT NULL,
[FE_ANUL] [dbo].[TD_DT_001] NULL,
[CO_PROV] [dbo].[TD_VC_020] NULL,
[CO_BANC] [dbo].[TD_VC_003] NULL,
[NU_CNTA_BANC] [dbo].[TD_VC_020] NULL,
[CO_CAJA] [dbo].[TD_VC_010] NULL,
[AA_BACA] [dbo].[TD_VC_004] NULL,
[MM_BACA] [dbo].[TD_VC_002] NULL,
[NU_COMP_BACA] [dbo].[TD_VC_008] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TCRETE_AN__CO_US__0C1BC9F9] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TCRETE_AN__FE_US__0D0FEE32] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TCRETE_AN__CO_US__0E04126B] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TCRETE_AN__FE_US__0EF836A4] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCRETE_ANUL] ADD CONSTRAINT [PK__TCRETE_A__AE11EDE356C9B771] PRIMARY KEY CLUSTERED  ([CO_EMPR], [NU_COMP_RETE]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCRETE_ANUL] ADD CONSTRAINT [FK__TCRETE_ANUL__1F2F69C4] FOREIGN KEY ([CO_EMPR], [NU_COMP_RETE]) REFERENCES [dbo].[TCCOMP_RETE] ([CO_EMPR], [NU_COMP_RETE])
GO
